@f{excel_data}

Displays the specified range of an Excel file in a UniPlot table. The Excel file is linked to the table by the file name. Press F9 to update the UniPlot table in the page.

The link can be edited with a right click.

The name of the field function and the parameters are entered in the name of the table. This can be done within a script with the function ref:ObjSetName. The field function can be set interactively via the dialog Edit Object=>Table Configuration

A new table can be created by right-clicking on the diagram. Use the command “More Functions=>Create Table Linked to Excel Sheet”.

@f{excel_data(FileName}

@f{excel_data(FileName, SheetName)}

@f{excel_data(FileName, SheetName, Range, InsertPosition)}

Parameters

FileName

The first parameter is the full name of the Excel file (XLSX, XLS).

SheetName

A table name can be specified as the second parameter. If the name is not specified, the function uses the first sheet.

Range

This parameter defines the cell range that is taken from the Excel spreadsheet. The range is specified in the a1 reference format. A1:B5 defines, for example, cells A1 to B5. If the parameter is not specified, the entire table is loaded. The UniPlot table size is not modified automatically. The UniPlot table displays only data that fit into the table.

InsertPosition

Sets the insert position in the a1 reference format. Default value is A1. For example, if you would like to have the first two rows empty or for other text, set the insert position to A3.

Example

@f{file(c:/temp/test.xlsx, Sheet1, A1:C10)}

output:

The defined section of the Excel table is then displayed in the output table.

See also

Overview Field Functions, Edit=>Update Fields, Diagram=>More Functions=>Diagramm=>Create Table Linked to Excel Sheet

_id-1429730